FaPackStatusPromoLevel

Logical Entity Name | FaPackStatusPromoLevel
Default Table Name | FaPackStatusPromoLevel
Physical Only | NO
Owner | dbo
Definition |
Note |

FaPackStatusPromoLevel Columns

ColumnName | Domain | Datatype | NULL | Definition
FaPackStatusPromoLevelID |  | int | NO |
FaPackStatusPromoID |  | int | NO |
PromotionLevel |  | smallint | NO |
FaPackStatusID |  | int | NO |
AllowManualChange |  | bit | NO |
AllowAutoPromotion |  | bit | NO |
Reevaluate |  | bit | NO |
RequireFAFSA |  | bit | NO |
RequireAwardLetter |  | bit | NO |
RequireValidISIR |  | bit | NO |
RequireVerificationCleared |  | bit | NO |
RequireAidOnFile |  | bit | NO |
RequireAidOverCOA |  | bit | NO |
RequireAidOverInstCost |  | bit | NO |
RequireApprovedAidOverCOA |  | bit | NO |
RequireApprovedAidOverInstCost |  | bit | NO |
RequireFADocsReceived |  | bit | NO |
CmDocTypeListID |  | int | YES |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
RequireFundSourceTypes |  | bit | NO |
SelectedFundSourceTypes |  | varchar(150) | YES |
UseAwardYear2 |  | bit | NO |
RequireAtLeastOneFADocReceived |  | bit | NO |

FaPackStatusPromoLevel Primary and Unique Keys

Key Name | Key Type | Keys
FaPackStatusPromoLevel_FaPackStatusPromoLevelID_U_C_IDX | PrimaryKey | FaPackStatusPromoLevelID

FaPackStatusPromoLevel Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

FaPackStatusPromoLevel Check Constraints

Check Constraint Name | CheckConstraint

FaPackStatusPromoLevel Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaPackStatusPromoLevel Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.PackagingStatusPromotionLevel | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaPackStatusPromoLevel | NO |  |  |

FaPackStatusPromoLevel Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaPackStatusPromoLevel Data Movement Rules

Name | Type | Rule Text/Value